excel中如何取得指定单元格的下两列的值?答:H1=INDEX({"A","B","C","D","E","F","G"},MATCH("yy",$A1:$H1,0))&row()H2=INDEX({"A","B","C","D","E","F","G"},MATCH("yy",$A2:$H2,0))&row()I1=INDEX($A1:$H1,1,MATCH("yy",$A1:$H1,0)+2)I2=INDEX($A2:$H2,1,MATCH("yy",$A2:$H2,0)...
excel如何利用函数返回某几个单元格的值到某一个单元格中答:D69公式:(数字之间用逗号,间隔。)=IF(COUNT(H69,H71,H73,H74,H76,H78),IFERROR(H69&",","")&IFERROR(H71&",","")&IFERROR(H73&",","")&IFERROR(H74&",","")&IFERROR(H76&",","")&IFERROR(H78&",",""),"无")如果不需要使用逗号间隔的,公式短些:=IF(COUNT(...